package com.wuseguang.springcloud.dao.jdbc;

import com.wuseguang.springcloud.JdbcTemplate.BaseTemplate;
import org.springframework.stereotype.Repository;

@Repository
public class StudentEvaluationScoreJdbc extends BaseTemplate {

    /**
     * 查询教师的分数显示规则id
     * @param teacherId
     * @return
     */
    public String findTeacherRule(String teacherId) {
        String sql = "select sdr.id string from score_display_rules sdr left join score_display_rules_teacher sdrt on(sdr.id=sdrt.score_display_rules_id)  where sdrt.teacher_id=?";
        return  queryString(sql,teacherId);
    }
}
